HI ... I have a detailed report ..with summary lines and detailed lines (drill down). I have a column with a function "RowNumber(Nothing)" which is supposed to just count the rows when I put this in the summary row for the column I need in the Design Layout section and run the report, I get numbers on the summary lines which include the number of rows in the level below (detailed rows). I just want to number the summary rows sequentially without taking into consideration, the number of detailed rows. How do I modify RowNumber(Nothing) to exclude counting the detailed rows....??? Any help will be much appreciated...thanks

To the folks who might face this problem I found the solution myself .....here it goes...just use this in the row you want to rumber (summary or detailed) =RunningValue(Fields!FieldNumber1.Value,CountDistinct,Nothing)

This was exactly what I was looking for thank you very much, you have been a great help

Excellent!! Thank you, I have looked every where for this......

Hi, Great Work Buddy, i too myself wandering on RowNumber() but it is inefficient when one wants to display row numbers based on group. Your technique is good, i too myself went with RunningValue() but unable to get desired result as i was giving the group name in scope and Count as function, now as in your example by giving Nothing in Scopeand CountDistinct in function it does the work.

"=RunningValue(Fields!FieldNumber1.Value,CountDistinct,Nothing)"it 's great! it gived me great help.Thank you .Aikon

Thank You